﻿CREATE TABLE [dbo].[Medicamente] (
    [idMedicament] INT            IDENTITY (1, 1) NOT NULL,
    [denumire]     NVARCHAR (255) NULL,
    [den_intern]   NVARCHAR (255) NULL,
    [producator]   NVARCHAR (255) NULL,
    [tara]         NVARCHAR (255) NULL,
    [prezentare]   NVARCHAR (255) NULL,
    [concentrat]   NVARCHAR (255) NULL,
    [um]           NVARCHAR (255) NULL,
    [codifatc]     NVARCHAR (255) NULL,
    [ut]           FLOAT (53)     NULL,
    [prescri]      NVARCHAR (255) NULL,
    [forma]        NVARCHAR (255) NULL,
    [Preferat]     BIT            NOT NULL,
    CONSTRAINT [PK_Medicamente] PRIMARY KEY CLUSTERED ([idMedicament] ASC)
);

